Tabela PrescriptionFavouriteDrug

Definicja tabeli PrescriptionFavouriteDrug

Name

PrescriptionFavouriteDrug

Code

PrescriptionFavouriteDrug

Comment

 


Lista kolumn tabeli PrescriptionFavouriteDrug

Name

Code

PrescriptionFavouriteDrugID

PrescriptionFavouriteDrugID

PersonnelID

PersonnelID

DrugNo

DrugNo

DrugDBTypeID

DrugDBTypeID

PatientID

PatientID

PatientDosageID

PatientDosageID

GeneralDosageID

GeneralDosageID


Kolumna PrescriptionFavouriteDrugID tabeli PrescriptionFavouriteDrug

Definicja kolumny PrescriptionFavouriteDrugID tabeli PrescriptionFavouriteDrug

Name

PrescriptionFavouriteDrugID

Code

PrescriptionFavouriteDrugID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelID tabeli PrescriptionFavouriteDrug

Definicja kolumny PersonnelID tabeli PrescriptionFavouriteDrug

Name

PersonnelID

Code

PersonnelID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DrugNo tabeli PrescriptionFavouriteDrug

Definicja kolumny DrugNo tabeli PrescriptionFavouriteDrug

Name

DrugNo

Code

DrugNo

Data Type

VARCHAR2(16)

Mandatory

Yes

Comment

 


Kolumna DrugDBTypeID tabeli PrescriptionFavouriteDrug

Definicja kolumny DrugDBTypeID tabeli PrescriptionFavouriteDrug

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientID tabeli PrescriptionFavouriteDrug

Definicja kolumny PatientID tabeli PrescriptionFavouriteDrug

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientDosageID tabeli PrescriptionFavouriteDrug

Definicja kolumny PatientDosageID tabeli PrescriptionFavouriteDrug

Name

PatientDosageID

Code

PatientDosageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GeneralDosageID tabeli PrescriptionFavouriteDrug

Definicja kolumny GeneralDosageID tabeli PrescriptionFavouriteDrug

Name

GeneralDosageID

Code

GeneralDosageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli PrescriptionFavouriteDrug

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PrescriptionFavouriteDrug

Definicja klucza Identifier_1 tabeli PrescriptionFavouriteDrug

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment